package com.cuit.freshmanMS.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cuit.freshmanMS.domain.Student;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ExcelMapper extends BaseMapper<Student> {
    //获取数据库中所有学生信息  用于导出
    List<Student> getAllStudentFromDB();

    //获取所有的身份证号
    List<Integer> getAllSidFromDB();

    //获取所有的学号
    List<Integer> getAllSnoFromDB();


    Integer getCnoByCname(String cname);
    String getCnameByCno(Integer cno);
    Integer getAnoByCname(String cname);
    String getAnameByAno(Integer ano);
    Integer getAnoByAname(String aname);
    Integer getAnoByCno(Integer cno);

    Boolean existClassInAca(String cname, String aname);


}
